﻿<%@ Page Title="" Language="C#" MasterPageFile="~/DashMaster.master" AutoEventWireup="true"
    CodeFile="dashboard.aspx.cs" Inherits="dashboard" %>

<%@ MasterType VirtualPath="~/DashMaster.master" %>
<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
    Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <link href="login-box.css" rel="stylesheet" type="text/css" />
    <table width="100%">
        <tr>
            <td align="right">
                <%--Project:
                <asp:DropDownList ID="ddlProject" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource1"
                    DataTextField="project_name" DataValueField="project_id" AutoPostBack="True">
                    <asp:ListItem Selected="True">All</asp:ListItem>
                </asp:DropDownList>--%>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
                    SelectCommand="SELECT [project_id], [project_name] FROM [Project_Master]"></asp:SqlDataSource>
            </td>
        </tr>
    </table>
    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
    </asp:ToolkitScriptManager>
    <br />
    <%-- <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1" EnableModelValidation="True" 
        onselectedindexchanged="GridView1_SelectedIndexChanged" Width="574px">
        <Columns>
            <asp:BoundField DataField="issue_id" HeaderText="issue_id" 
                SortExpression="issue_id" />
            <asp:BoundField DataField="issue_description" HeaderText="issue_description" 
                SortExpression="issue_description" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT Issue_Master.issue_id, Issue_Master.issue_description FROM Issue_Master INNER JOIN Issue_Solving_Entry ON Issue_Master.issue_id &lt;&gt; Issue_Solving_Entry.issue_id INNER JOIN Modulewise_Issue_Assignment ON Issue_Master.issue_id &lt;&gt; Modulewise_Issue_Assignment.issue_id">
    </asp:SqlDataSource>--%>
    <asp:TabContainer ID="TabContainer1" runat="server" ActiveTabIndex="0" Width="100%">
        <asp:TabPanel ID="TabPanel1" runat="server" HeaderText="Unassigned">
            <ContentTemplate>
                <asp:GridView ID="gridUnassigned" runat="server" Width="100%" AutoGenerateColumns="False"
                    OnRowDataBound="gridUnassigned_RowDataBound">
                    <Columns>
                        <asp:HyperLinkField DataTextField="Issue ID" DataNavigateUrlFields="Issue ID" DataNavigateUrlFormatString="~\Issuedetails.aspx?IssueID={0}"
                            HeaderText="Issue ID" Target="_self" ItemStyle-Width="25%">
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:HyperLinkField>
                        <asp:BoundField DataField="Description" HeaderText="Description" />
                    </Columns>
                </asp:GridView>
            </ContentTemplate>
        </asp:TabPanel>
        <asp:TabPanel ID="TabPane2" runat="server" HeaderText="Resolved">
            <ContentTemplate>
                <asp:GridView ID="gridResolved" runat="server" Width="100%" AutoGenerateColumns="False"
                    OnRowDataBound="gridUnassigned_RowDataBound">
                    <Columns>
                        <asp:HyperLinkField ItemStyle-Font-Strikeout="true" DataTextField="Issue ID" DataNavigateUrlFields="Issue ID"
                            DataNavigateUrlFormatString="~\Issuedetails.aspx?IssueID={0}" HeaderText="Issue ID"
                            Target="_self" ItemStyle-Width="25%">
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:HyperLinkField>
                        <asp:BoundField DataField="Description" HeaderText="Description" />
                    </Columns>
                </asp:GridView>
            </ContentTemplate>
        </asp:TabPanel>
        <asp:TabPanel ID="TabPanel3" runat="server" HeaderText="Recently Modified">
            <ContentTemplate>
                <asp:GridView ID="gridModified" runat="server" Width="100%" AutoGenerateColumns="False"
                    OnRowDataBound="gridUnassigned_RowDataBound">
                    <Columns>
                        <asp:HyperLinkField DataTextField="Issue ID" DataNavigateUrlFormatString="~\Issuedetails.aspx?IssueID={0}"
                            DataNavigateUrlFields="Issue ID" HeaderText="Issue ID" Target="_self">
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:HyperLinkField>
                        <asp:BoundField DataField="Description" HeaderText="Description" />
                        <asp:BoundField DataField="Modified Date" HeaderText="Modified Date">
                            <ItemStyle Width="25%" />
                        </asp:BoundField>
                    </Columns>
                </asp:GridView>
            </ContentTemplate>
        </asp:TabPanel>
        <asp:TabPanel ID="TabPanel4" runat="server" HeaderText="Reported By Me">
            <ContentTemplate>
                <asp:GridView ID="gridReported" runat="server" Width="100%" AutoGenerateColumns="False"
                    OnRowDataBound="gridUnassigned_RowDataBound">
                    <Columns>
                        <asp:HyperLinkField DataTextField="Issue ID" DataNavigateUrlFields="Issue ID" DataNavigateUrlFormatString="~\Issuedetails.aspx?IssueID={0}"
                            HeaderText="Issue ID" Target="_self">
                            <ItemStyle HorizontalAlign="Center" />
                        </asp:HyperLinkField>
                        <asp:BoundField DataField="Description" HeaderText="Description" />
                    </Columns>
                </asp:GridView>
            </ContentTemplate>
        </asp:TabPanel>
        <%--<asp:TabPanel ID="TabPanel5" runat="server" HeaderText="Submitted By Me">
                <ContentTemplate>
                    <asp:GridView ID="GridView5" runat="server">
                    </asp:GridView>
                </ContentTemplate>
            </asp:TabPanel>--%>
    </asp:TabContainer>
    <table width="100%">
        <tr style="width: 100%">
            <td class="none" style="width: 16.5%">
                None
            </td>
            <td class="low" style="width: 16.5%">
                Low
            </td>
            <td class="normal" style="width: 16.5%">
                Normal
            </td>
            <td class="high" style="width: 16.5%">
                High
            </td>
            <td class="urgent" style="width: 16.5%">
                Urgent
            </td>
            <td class="immediate" style="width: 16.5%">
                Immediate
            </td>
        </tr>
    </table>
    <br />
    <br />
    <br />
    <asp:Label runat="server" Text="Projects:" Font-Bold="True" Font-Size="X-Large" Font-Underline="True"></asp:Label>
    <asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource2" BackColor="Transparent"
        Width="900px" BackImageWrapMode="Unscaled" BorderlineColor="Black" Style="text-align: center;
        width: 100%" BorderlineDashStyle="DashDot" BackImageTransparentColor="Transparent"
        BorderSkin-BackColor="Transparent" BorderSkin-PageColor="Transparent" ImageType="Png">
        <%--<BorderSkin BackColor="Transparent" PageColor="Transparent" SkinStyle="Emboss" />--%>
        <Series>
            <asp:Series Name="Series1" ChartType="Pie" XValueMember="Status" YValueMembers="Count"
                YValuesPerPoint="2" IsValueShownAsLabel="True" Legend="Legend1">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </ChartAreas>
        <Legends>
            <asp:Legend BackColor="Transparent" LegendStyle="Column" Name="Legend1" Font="Microsoft Sans Serif, 14pt"
                ForeColor="Black" IsTextAutoFit="True">
            </asp:Legend>
        </Legends>
    </asp:Chart>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>">
    </asp:SqlDataSource>
    <br />
    <%-- SelectCommand="SELECT COUNT(issue_status) AS Count, issue_status AS Status FROM Issue_Master GROUP BY issue_status"--%>
    <br />
    <%--<table width="100%">
        <tr style="width: 100%">
            <td class="none" style="width: 16.5%">
                None
            </td>
            <td class="low" style="width: 16.5%">
                Low
            </td>
            <td class="normal" style="width: 16.5%">
                Normal
            </td>
            <td class="high" style="width: 16.5%">
                High
            </td>
            <td class="urgent" style="width: 16.5%">
                Urgent
            </td>
            <td class="immediate" style="width: 16.5%">
                Immediate
            </td>
        </tr>
    </table>--%>
</asp:Content>
